/*************************************************************************
* Drop Constraint
**************************************************************************/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Club_x_Profile_Profile]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[Club_x_Profile] DROP CONSTRAINT FK_Club_x_Profile_Profile
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Club_x_Profile_Club]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[Club_x_Profile] DROP CONSTRAINT FK_Club_x_Profile_Club
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Message_Board]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[Message] DROP CONSTRAINT FK_Message_Board
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Board_Club]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[Board] DROP CONSTRAINT FK_Board_Club
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Message_Club]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[Message] DROP CONSTRAINT FK_Message_Club
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Comment_Message]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[Comment] DROP CONSTRAINT FK_Comment_Message
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_PollItem_Message]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[PollItem] DROP CONSTRAINT FK_PollItem_Message
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Profile_x_PollMessage_Message]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[Profile_x_PollMessage] DROP CONSTRAINT FK_Profile_x_PollMessage_Message
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Board_Profile]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[Board] DROP CONSTRAINT FK_Board_Profile
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Comment_Profile]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[Comment] DROP CONSTRAINT FK_Comment_Profile
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Message_Profile]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[Message] DROP CONSTRAINT FK_Message_Profile
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Profile_x_PollMessage_Profile]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[Profile_x_PollMessage] DROP CONSTRAINT FK_Profile_x_PollMessage_Profile
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_UserRole_x_Profile_Profile]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[UserRole_x_Profile] DROP CONSTRAINT FK_UserRole_x_Profile_Profile
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Board_UserRole]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[Board] DROP CONSTRAINT FK_Board_UserRole
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Board_UserRole1]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[Board] DROP CONSTRAINT FK_Board_UserRole1
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_UserRole_x_Profile_UserRole]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[UserRole_x_Profile] DROP CONSTRAINT FK_UserRole_x_Profile_UserRole
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Club_ClubCategory]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[Club] DROP CONSTRAINT FK_Club_ClubCategory
GO

/*************************************************************************
* Drop table
**************************************************************************/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Club_x_Profile]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Club_x_Profile]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Attachment]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Attachment]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Board]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Board]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ClubCategory]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ClubCategory]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Club]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Club]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Comment]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Comment]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Message]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Message]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PollItem]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[PollItem]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Profile]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Profile]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Profile_x_PollMessage]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Profile_x_PollMessage]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UserRole]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[UserRole]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UserRole_x_Profile]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[UserRole_x_Profile]
GO


/* Stored Procedure exist check */
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AddRoleToProfile]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[AddRoleToProfile]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DeleteAttachment]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[DeleteAttachment]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DeleteComment]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[DeleteComment]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DeleteMessage]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[DeleteMessage]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DeletePollItem]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[DeletePollItem]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DeleteProfile]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[DeleteProfile]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DeleteRoleFromProfile]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[DeleteRoleFromProfile]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DeleteUserRole]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[DeleteUserRole]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetUserRoleById]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetUserRoleById]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetAllUserRoles]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetAllUserRoles]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetAttachmentsByMessageId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetAttachmentsByMessageId]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetCommentsByMessageId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetCommentsByMessageId]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetPollItemsByMessageId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetPollItemsByMessageId]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetRepliesByMessageId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetRepliesByMessageId]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetAllUserProfiles]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetAllUserProfiles]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetUserProfileById]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetUserProfileById]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetUserProfileByUserId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetUserProfileByUserId]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetUserProfileByUserIdAndPassword]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetUserProfileByUserIdAndPassword]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetUserRolesByProfileId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetUserRolesByProfileId]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetVoterByVoterIdAndMessageId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetVoterByVoterIdAndMessageId]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[InsertAttachment]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[InsertAttachment]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[InsertBoard]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[InsertBoard]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[InsertComment]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[InsertComment]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[InsertMessage]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[InsertMessage]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[InsertPollItem]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[InsertPollItem]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[InsertUserRole]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[InsertUserRole]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetTotalRootMessageCountByBoardId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetTotalRootMessageCountByBoardId]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetMessageListByBoardId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetMessageListByBoardId]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UpdateBoard]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[UpdateBoard]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UpdateUserRole]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[UpdateUserRole]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetMessageByMessageId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetMessageByMessageId]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UpdateMessage]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[UpdateMessage]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetVoterByUserIdAndMessageId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetVoterByUserIdAndMessageId]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DeleteClub]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[DeleteClub]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DeleteBoard]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[DeleteBoard]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetBoardById]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetBoardById]
GO


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetClubList]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetClubList]
GO


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetBoardListByClubId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetBoardListByClubId]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetClubById]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetClubById]
GO

/****** Object:  Stored Procedure dbo.InsertUserClubProfile    Script Date: 2/13/2005 7:21:23 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[InsertUserClubProfile]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[InsertUserClubProfile]
GO


/****** Object:  Stored Procedure dbo.DeleteUserClubProfile    Script Date: 2/13/2005 7:21:23 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DeleteUserClubProfile]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[DeleteUserClubProfile]
GO


/****** Object:  Stored Procedure dbo.UpdateUserClubProfile    Script Date: 2/13/2005 7:21:23 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UpdateUserClubProfile]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[UpdateUserClubProfile]
GO


/****** Object:  Stored Procedure dbo.GetAllUserClubProfileByClubId    Script Date: 2/13/2005 7:21:23 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetAllUserClubProfileByClubId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetAllUserClubProfileByClubId]
GO

/****** Object:  Stored Procedure dbo.GetUserClubProfileByProfileIdAndClubId    Script Date: 2/13/2005 7:21:23 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetUserClubProfileByProfileIdAndClubId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetUserClubProfileByProfileIdAndClubId]
GO
/****** Object:  Stored Procedure dbo.DeleteClubRole    Script Date: 2/13/2005 7:21:23 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DeleteClubRole]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[DeleteClubRole]
GO

/****** Object:  Stored Procedure dbo.DeleteClubRoleFromProfile    Script Date: 2/13/2005 7:21:23 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DeleteClubRoleFromProfile]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[DeleteClubRoleFromProfile]
GO
/****** Object:  Stored Procedure dbo.GetAllClubRoles    Script Date: 2/13/2005 7:21:23 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetAllClubRoles]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetAllClubRoles]
GO

/****** Object:  Stored Procedure dbo.GetClubRoleById    Script Date: 2/13/2005 7:21:23 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetClubRoleById]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetClubRoleById]
GO


/****** Object:  Stored Procedure dbo.GetClubRolesByProfileId    Script Date: 2/13/2005 7:21:23 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetClubRolesByProfileId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetClubRolesByProfileId]
GO

/****** Object:  Stored Procedure dbo.InsertClubRole    Script Date: 2/13/2005 7:21:23 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[InsertClubRole]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[InsertClubRole]
GO

/****** Object:  Stored Procedure dbo.UpdateClubRole    Script Date: 2/13/2005 7:21:23 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UpdateClubRole]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[UpdateClubRole]
GO
/****** Object:  Stored Procedure dbo.AddClubRoleToProfile    Script Date: 2/13/2005 7:21:23 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AddClubRoleToProfile]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[AddClubRoleToProfile]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetAllClubsThatUserJoined]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetAllClubsThatUserJoined]
GO

/****** Object:  Stored Procedure dbo.InsertVoteForMessage    Script Date: 2/13/2005 7:21:23 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[InsertVoteForMessage]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[InsertVoteForMessage]
GO

/****** Object:  Stored Procedure dbo.GetVoteListByMessageId    Script Date: 2/13/2005 7:21:23 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetVoteListByMessageId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetVoteListByMessageId]
GO

/****** Object:  Stored Procedure dbo.InsertPoll    Script Date: 2/13/2005 7:21:23 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[InsertPoll]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[InsertPoll]
GO

/****** Object:  Stored Procedure dbo.GetTotalRootMessageCountByClubId    Script Date: 2/13/2005 7:21:23 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetTotalRootMessageCountByClubId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetTotalRootMessageCountByClubId]
GO
/****** Object:  Stored Procedure dbo.GetMessageListByClubId    Script Date: 2/13/2005 7:21:23 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetMessageListByClubId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetMessageListByClubId]
GO
/****** Object:  Stored Procedure dbo.InsertProfile    Script Date: 2/13/2005 7:21:23 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[InsertProfile]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[InsertProfile]
GO

/****** Object:  Stored Procedure dbo.UpdateProfile    Script Date: 2/13/2005 7:21:23 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UpdateProfile]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[UpdateProfile]
GO

/****** Object:  Stored Procedure dbo.InsertClub    Script Date: 2/13/2005 7:21:23 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[InsertClub]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[InsertClub]
GO

/****** Object:  Stored Procedure dbo.UpdateClub    Script Date: 2/13/2005 7:21:23 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UpdateClub]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[UpdateClub]
GO

